package com.qf.business.goods.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.qf.data.goods.entity.GoodsInfo;
import com.qf.data.goods.vo.output.GoodsFengMian;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * (GoodsInfo)表数据库访问层
 *
 * @author makejava
 * @since 2022-07-12 15:44:54
 */
public interface GoodsInfoMapper extends BaseMapper<GoodsInfo> {
    @Select("select g.*, i.image as image, s.sort_name as sort \n" +
            "\tfrom goods_info g\n" +
            "\tjoin goods_image i on g.id = i.gid\n" +
            "\tjoin goods_sort s on g.sid = s.id\n" +
            "\twhere i.type = 1\n")
    List<GoodsFengMian> querySystemList();
}

